Promotions are imported through the Promotions menu.
Go to: Back Office > File > Sales > Promotions > Promotions > Select the "Import" option.
It’s possible to import promotions using the following headers:
ZONE, DESCRIPTION, TRIP_QUANTITY, PROMO_PRICE, START_DATE, END_DATE, ITEM_CODE, CUSTOMER_TYPE, CUSTOMERTYPE, CUSTOMERTYPERANGE, CUSTOMER_TYPE_RANGE, POS, POS_NUMBER, TERMINAL, POS_RANGE, LOCATION, LOCATION_RANGE, SITE, SITE_RANGE, PRICE_LEVEL
The Promotion Group will be created when the file is imported and is based on the filename being imported.
If one of the items imported is within an Attribute family, the other items within the family will be imported automatically.
A family item is any item that has been linked to the designated Family Stock Item Attribute. This can be set by going to Setup > Global Options > Other Options > Stock Item Linking > Attribute Type.
ZONE – Currently unused but included for future plans. Header must be included but data can be left blank.
DESCRIPTION – Promotion Description.
TRIP_QUANTITY – The number of items required to purchase to trip the promotion (e.g. buy 3 quantity of the item to trip the promotion). Both TRIP_QUANTITY and TRIP_AMOUNT can be used in the Promotion Import File, however, if a value is entered in both the TRIP_QUANTITY and TRIP_AMOUNT fields, the TRIP_AMOUNT will take precedence. If a TRIP_GROUP header with a value between 1 to 3 has not been included in the Promo Import File, the Trip Quantity will be set against the Trip Group 1/Trip Condition Set 1 by default. Also note that it isn't necessary to populate the TRIP_QUANTITY field for every item in a Trip Group. Populating this field for the first item within a Trip Group/Trip Condition Set will result in all consecutive items in that Trip Group inheriting the same Trip Quantity. It should also be noted that if the Trip Quantity differs for each item in a Trip Group/Trip Condition Set, the last item in the Trip Group which contains a Trip Quantity value will be set as the Trip Quantity for that entire Trip Group.
TRIP_AMOUNT – This option is available in v7.1 Build 15 and newer. The dollar value that the customer needs to spend on items included in the promotion to trip the promotion (e.g. spend $X.XX on these items to trip the promotion). A whole number (e.g. 5) or decimal value (e.g. 5.50) can be specified. Both TRIP_QUANTITY and TRIP_AMOUNT can be used in the Promotion Import File, however, if a value is entered in both the TRIP_QUANTITY and TRIP_AMOUNT fields, the TRIP_AMOUNT will take precedence. If a TRIP_GROUP header with a value between 1 to 3 has not been included in the Promo Import File, the Trip Amount will be set against the Trip Group 1/Trip Condition Set 1 by default. Also note that it isn't necessary to populate the TRIP_AMOUNT field for every item in a Trip Group. Populating this field for the first item within a Trip Group/Trip Condition Set will result in all consecutive items in that Trip Group inheriting the same Trip value. It should also be noted that if the Trip Amount differs for each item in a Trip Group/Trip Condition Set, the last item in the Trip Group which contains a Trip Amount value will be set as the Trip Amount for that entire Trip Group.
PROMO_PRICE – Price of the promotion.
START_DATE – Start date of the promotion.
END_DATE – End date of the promotion.
ITEM_CODE – Stock items to be included in the promotion.
CUSTOMER_TYPE or CUSTOMERTYPE - Customer Type Code
CUSTOMERTYPERANGE or CUSTOMER_TYPE_RANGE - The range of Customer Type Codes expressed as 1-4, 16. Anything fields that contain a comma must be contained within quotes, so "1-4, 16".
POS or POS_NUMBER or TERMINAL - POS Terminal Code
POS_RANGE - POS Terminal Code range expressed as 1-4, 16. Anything fields that contain a comma must be contained within quotes, so "1-4, 16".
LOCATION - The Location Code
LOCATION_RANGE - The Location Code range expressed as 1-4, 16. Anything fields that contain a comma must be contained within quotes, so "1-4, 16".
SCAN_CODE - The Scan Code of the Stock Item to be included in the promotion. If the Item_Code is blank, it will attempt to find the item using the Scan_Code.
SITE - The Site Code
SITE_RANGE - The Site Code range expressed as 1-4, 16. Anything fields that contain a comma must be contained within quotes, so "1-4, 16".
PRICE_LEVEL - The Price Level Code.
DISCOUNT_TYPE - This option is available in v7.1 Build 15 and newer. The type of discount you want to create. To specify the Discount Type, enter the integer that corresponds to the Discount Type you want to create. Discount Types are listed below:
1 - $ Discount off Items
2 - % Discount off Items
3 - Fixed Price for Items
4 - Bonus Stock Item (use a BONUS_ITEM header in the Import File and enter the Bonus Stock Item Code within the field)
5 - Cheapest Item % Discount
6 - Unit Price Each
7 - $ Discount off Total
8 - Expensive Item % Discount
9 - $ Discount Each Item
TRIP_GROUP - This option is available in v7.1 Build 15 and newer. This is the Trip Group/Trip Conditions Set that the Items will be listed in within the Promotion. Three Trip Groups are available; enter 1, 2 or 3. If a TRIP_GROUP is not included, Idealpos will default to using TRIP_GROUP 1.
As the POS Range, Location Range, Site Range, Price Level all share the same field, whichever field comes first will take precedence if you have a record that has data in both fields.
Once you have created the file, go to File > Sales > Promotions > Promotions > Import > Select your file > Open.
The promotion(s) will be added to the list where you can further edit them for additional options.
This function will allow you to find out what Promotion an item is included in before you enter the item into a sale.
Select this button and press the enter the stock item and the promotions will be displayed on screen.
Go to Setup > POS Screen > POS Screen Setup > Function: Promotion Enquiry.
This features allows you to check if the item is part of a promotion and the price will change when the sale is finished.
Go to Setup > POS Screen > POS Screen Setup > Function: Price Enquiry.
During a sale you can press the button, and select an item.
A message will display on screen showing the item and price.
If the item is available for any type of promotion, you can select to view the applicable promotions to see what can affect the price of the item when sold.
When you select Yes, the Promotions Enquiry screen will display.
